package com.dc.gameserver.serverCore.model.dbsql.modelVo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TRoleExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer limitStart;

    protected Integer limitEnd;

    public TRoleExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(Integer limitStart) {
        this.limitStart=limitStart;
    }

    public Integer getLimitStart() {
        return limitStart;
    }

    public void setLimitEnd(Integer limitEnd) {
        this.limitEnd=limitEnd;
    }

    public Integer getLimitEnd() {
        return limitEnd;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andRoleidIsNull() {
            addCriterion("ROLEID is null");
            return (Criteria) this;
        }

        public Criteria andRoleidIsNotNull() {
            addCriterion("ROLEID is not null");
            return (Criteria) this;
        }

        public Criteria andRoleidEqualTo(Integer value) {
            addCriterion("ROLEID =", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidNotEqualTo(Integer value) {
            addCriterion("ROLEID <>", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidGreaterThan(Integer value) {
            addCriterion("ROLEID >", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEID >=", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidLessThan(Integer value) {
            addCriterion("ROLEID <", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEID <=", value, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidIn(List<Integer> values) {
            addCriterion("ROLEID in", values, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidNotIn(List<Integer> values) {
            addCriterion("ROLEID not in", values, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidBetween(Integer value1, Integer value2) {
            addCriterion("ROLEID between", value1, value2, "roleid");
            return (Criteria) this;
        }

        public Criteria andRoleidNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEID not between", value1, value2, "roleid");
            return (Criteria) this;
        }

        public Criteria andUseridIsNull() {
            addCriterion("USERID is null");
            return (Criteria) this;
        }

        public Criteria andUseridIsNotNull() {
            addCriterion("USERID is not null");
            return (Criteria) this;
        }

        public Criteria andUseridEqualTo(Integer value) {
            addCriterion("USERID =", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotEqualTo(Integer value) {
            addCriterion("USERID <>", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThan(Integer value) {
            addCriterion("USERID >", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("USERID >=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThan(Integer value) {
            addCriterion("USERID <", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridLessThanOrEqualTo(Integer value) {
            addCriterion("USERID <=", value, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridIn(List<Integer> values) {
            addCriterion("USERID in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotIn(List<Integer> values) {
            addCriterion("USERID not in", values, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridBetween(Integer value1, Integer value2) {
            addCriterion("USERID between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andUseridNotBetween(Integer value1, Integer value2) {
            addCriterion("USERID not between", value1, value2, "userid");
            return (Criteria) this;
        }

        public Criteria andRolenameIsNull() {
            addCriterion("ROLENAME is null");
            return (Criteria) this;
        }

        public Criteria andRolenameIsNotNull() {
            addCriterion("ROLENAME is not null");
            return (Criteria) this;
        }

        public Criteria andRolenameEqualTo(String value) {
            addCriterion("ROLENAME =", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameNotEqualTo(String value) {
            addCriterion("ROLENAME <>", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameGreaterThan(String value) {
            addCriterion("ROLENAME >", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameGreaterThanOrEqualTo(String value) {
            addCriterion("ROLENAME >=", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameLessThan(String value) {
            addCriterion("ROLENAME <", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameLessThanOrEqualTo(String value) {
            addCriterion("ROLENAME <=", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameLike(String value) {
            addCriterion("ROLENAME like", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameNotLike(String value) {
            addCriterion("ROLENAME not like", value, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameIn(List<String> values) {
            addCriterion("ROLENAME in", values, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameNotIn(List<String> values) {
            addCriterion("ROLENAME not in", values, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameBetween(String value1, String value2) {
            addCriterion("ROLENAME between", value1, value2, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolenameNotBetween(String value1, String value2) {
            addCriterion("ROLENAME not between", value1, value2, "rolename");
            return (Criteria) this;
        }

        public Criteria andRolesexIsNull() {
            addCriterion("ROLESEX is null");
            return (Criteria) this;
        }

        public Criteria andRolesexIsNotNull() {
            addCriterion("ROLESEX is not null");
            return (Criteria) this;
        }

        public Criteria andRolesexEqualTo(Byte value) {
            addCriterion("ROLESEX =", value, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexNotEqualTo(Byte value) {
            addCriterion("ROLESEX <>", value, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexGreaterThan(Byte value) {
            addCriterion("ROLESEX >", value, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexGreaterThanOrEqualTo(Byte value) {
            addCriterion("ROLESEX >=", value, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexLessThan(Byte value) {
            addCriterion("ROLESEX <", value, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexLessThanOrEqualTo(Byte value) {
            addCriterion("ROLESEX <=", value, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexIn(List<Byte> values) {
            addCriterion("ROLESEX in", values, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexNotIn(List<Byte> values) {
            addCriterion("ROLESEX not in", values, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexBetween(Byte value1, Byte value2) {
            addCriterion("ROLESEX between", value1, value2, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRolesexNotBetween(Byte value1, Byte value2) {
            addCriterion("ROLESEX not between", value1, value2, "rolesex");
            return (Criteria) this;
        }

        public Criteria andRoletypeIsNull() {
            addCriterion("ROLETYPE is null");
            return (Criteria) this;
        }

        public Criteria andRoletypeIsNotNull() {
            addCriterion("ROLETYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRoletypeEqualTo(Integer value) {
            addCriterion("ROLETYPE =", value, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeNotEqualTo(Integer value) {
            addCriterion("ROLETYPE <>", value, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeGreaterThan(Integer value) {
            addCriterion("ROLETYPE >", value, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLETYPE >=", value, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeLessThan(Integer value) {
            addCriterion("ROLETYPE <", value, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeLessThanOrEqualTo(Integer value) {
            addCriterion("ROLETYPE <=", value, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeIn(List<Integer> values) {
            addCriterion("ROLETYPE in", values, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeNotIn(List<Integer> values) {
            addCriterion("ROLETYPE not in", values, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeBetween(Integer value1, Integer value2) {
            addCriterion("ROLETYPE between", value1, value2, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoletypeNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLETYPE not between", value1, value2, "roletype");
            return (Criteria) this;
        }

        public Criteria andRoleageIsNull() {
            addCriterion("ROLEAGE is null");
            return (Criteria) this;
        }

        public Criteria andRoleageIsNotNull() {
            addCriterion("ROLEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andRoleageEqualTo(Long value) {
            addCriterion("ROLEAGE =", value, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageNotEqualTo(Long value) {
            addCriterion("ROLEAGE <>", value, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageGreaterThan(Long value) {
            addCriterion("ROLEAGE >", value, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageGreaterThanOrEqualTo(Long value) {
            addCriterion("ROLEAGE >=", value, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageLessThan(Long value) {
            addCriterion("ROLEAGE <", value, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageLessThanOrEqualTo(Long value) {
            addCriterion("ROLEAGE <=", value, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageIn(List<Long> values) {
            addCriterion("ROLEAGE in", values, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageNotIn(List<Long> values) {
            addCriterion("ROLEAGE not in", values, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageBetween(Long value1, Long value2) {
            addCriterion("ROLEAGE between", value1, value2, "roleage");
            return (Criteria) this;
        }

        public Criteria andRoleageNotBetween(Long value1, Long value2) {
            addCriterion("ROLEAGE not between", value1, value2, "roleage");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodIsNull() {
            addCriterion("ROLEMAXBLOOD is null");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodIsNotNull() {
            addCriterion("ROLEMAXBLOOD is not null");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodEqualTo(Integer value) {
            addCriterion("ROLEMAXBLOOD =", value, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodNotEqualTo(Integer value) {
            addCriterion("ROLEMAXBLOOD <>", value, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodGreaterThan(Integer value) {
            addCriterion("ROLEMAXBLOOD >", value, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXBLOOD >=", value, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodLessThan(Integer value) {
            addCriterion("ROLEMAXBLOOD <", value, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXBLOOD <=", value, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodIn(List<Integer> values) {
            addCriterion("ROLEMAXBLOOD in", values, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodNotIn(List<Integer> values) {
            addCriterion("ROLEMAXBLOOD not in", values, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXBLOOD between", value1, value2, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxbloodNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXBLOOD not between", value1, value2, "rolemaxblood");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicIsNull() {
            addCriterion("ROLEMAXMAGIC is null");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicIsNotNull() {
            addCriterion("ROLEMAXMAGIC is not null");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicEqualTo(Integer value) {
            addCriterion("ROLEMAXMAGIC =", value, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicNotEqualTo(Integer value) {
            addCriterion("ROLEMAXMAGIC <>", value, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicGreaterThan(Integer value) {
            addCriterion("ROLEMAXMAGIC >", value, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXMAGIC >=", value, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicLessThan(Integer value) {
            addCriterion("ROLEMAXMAGIC <", value, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXMAGIC <=", value, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicIn(List<Integer> values) {
            addCriterion("ROLEMAXMAGIC in", values, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicNotIn(List<Integer> values) {
            addCriterion("ROLEMAXMAGIC not in", values, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXMAGIC between", value1, value2, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxmagicNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXMAGIC not between", value1, value2, "rolemaxmagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicIsNull() {
            addCriterion("ROLERECOVERYMAGIC is null");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicIsNotNull() {
            addCriterion("ROLERECOVERYMAGIC is not null");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicEqualTo(Integer value) {
            addCriterion("ROLERECOVERYMAGIC =", value, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicNotEqualTo(Integer value) {
            addCriterion("ROLERECOVERYMAGIC <>", value, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicGreaterThan(Integer value) {
            addCriterion("ROLERECOVERYMAGIC >", value, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLERECOVERYMAGIC >=", value, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicLessThan(Integer value) {
            addCriterion("ROLERECOVERYMAGIC <", value, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicLessThanOrEqualTo(Integer value) {
            addCriterion("ROLERECOVERYMAGIC <=", value, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicIn(List<Integer> values) {
            addCriterion("ROLERECOVERYMAGIC in", values, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicNotIn(List<Integer> values) {
            addCriterion("ROLERECOVERYMAGIC not in", values, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicBetween(Integer value1, Integer value2) {
            addCriterion("ROLERECOVERYMAGIC between", value1, value2, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolerecoverymagicNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLERECOVERYMAGIC not between", value1, value2, "rolerecoverymagic");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledIsNull() {
            addCriterion("ROLEMAXSHILED is null");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledIsNotNull() {
            addCriterion("ROLEMAXSHILED is not null");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledEqualTo(Integer value) {
            addCriterion("ROLEMAXSHILED =", value, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledNotEqualTo(Integer value) {
            addCriterion("ROLEMAXSHILED <>", value, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledGreaterThan(Integer value) {
            addCriterion("ROLEMAXSHILED >", value, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXSHILED >=", value, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledLessThan(Integer value) {
            addCriterion("ROLEMAXSHILED <", value, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXSHILED <=", value, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledIn(List<Integer> values) {
            addCriterion("ROLEMAXSHILED in", values, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledNotIn(List<Integer> values) {
            addCriterion("ROLEMAXSHILED not in", values, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXSHILED between", value1, value2, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRolemaxshiledNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXSHILED not between", value1, value2, "rolemaxshiled");
            return (Criteria) this;
        }

        public Criteria andRoleattackIsNull() {
            addCriterion("ROLEATTACK is null");
            return (Criteria) this;
        }

        public Criteria andRoleattackIsNotNull() {
            addCriterion("ROLEATTACK is not null");
            return (Criteria) this;
        }

        public Criteria andRoleattackEqualTo(Integer value) {
            addCriterion("ROLEATTACK =", value, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackNotEqualTo(Integer value) {
            addCriterion("ROLEATTACK <>", value, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackGreaterThan(Integer value) {
            addCriterion("ROLEATTACK >", value, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEATTACK >=", value, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackLessThan(Integer value) {
            addCriterion("ROLEATTACK <", value, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEATTACK <=", value, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackIn(List<Integer> values) {
            addCriterion("ROLEATTACK in", values, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackNotIn(List<Integer> values) {
            addCriterion("ROLEATTACK not in", values, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackBetween(Integer value1, Integer value2) {
            addCriterion("ROLEATTACK between", value1, value2, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoleattackNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEATTACK not between", value1, value2, "roleattack");
            return (Criteria) this;
        }

        public Criteria andRoledefenceIsNull() {
            addCriterion("ROLEDEFENCE is null");
            return (Criteria) this;
        }

        public Criteria andRoledefenceIsNotNull() {
            addCriterion("ROLEDEFENCE is not null");
            return (Criteria) this;
        }

        public Criteria andRoledefenceEqualTo(Integer value) {
            addCriterion("ROLEDEFENCE =", value, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceNotEqualTo(Integer value) {
            addCriterion("ROLEDEFENCE <>", value, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceGreaterThan(Integer value) {
            addCriterion("ROLEDEFENCE >", value, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEDEFENCE >=", value, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceLessThan(Integer value) {
            addCriterion("ROLEDEFENCE <", value, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEDEFENCE <=", value, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceIn(List<Integer> values) {
            addCriterion("ROLEDEFENCE in", values, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceNotIn(List<Integer> values) {
            addCriterion("ROLEDEFENCE not in", values, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceBetween(Integer value1, Integer value2) {
            addCriterion("ROLEDEFENCE between", value1, value2, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRoledefenceNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEDEFENCE not between", value1, value2, "roledefence");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeIsNull() {
            addCriterion("ROLEFIVETYPE is null");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeIsNotNull() {
            addCriterion("ROLEFIVETYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeEqualTo(Byte value) {
            addCriterion("ROLEFIVETYPE =", value, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeNotEqualTo(Byte value) {
            addCriterion("ROLEFIVETYPE <>", value, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeGreaterThan(Byte value) {
            addCriterion("ROLEFIVETYPE >", value, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("ROLEFIVETYPE >=", value, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeLessThan(Byte value) {
            addCriterion("ROLEFIVETYPE <", value, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeLessThanOrEqualTo(Byte value) {
            addCriterion("ROLEFIVETYPE <=", value, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeIn(List<Byte> values) {
            addCriterion("ROLEFIVETYPE in", values, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeNotIn(List<Byte> values) {
            addCriterion("ROLEFIVETYPE not in", values, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeBetween(Byte value1, Byte value2) {
            addCriterion("ROLEFIVETYPE between", value1, value2, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolefivetypeNotBetween(Byte value1, Byte value2) {
            addCriterion("ROLEFIVETYPE not between", value1, value2, "rolefivetype");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumIsNull() {
            addCriterion("ROLEBASEMAXMOMENTUM is null");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumIsNotNull() {
            addCriterion("ROLEBASEMAXMOMENTUM is not null");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumEqualTo(Integer value) {
            addCriterion("ROLEBASEMAXMOMENTUM =", value, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumNotEqualTo(Integer value) {
            addCriterion("ROLEBASEMAXMOMENTUM <>", value, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumGreaterThan(Integer value) {
            addCriterion("ROLEBASEMAXMOMENTUM >", value, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEBASEMAXMOMENTUM >=", value, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumLessThan(Integer value) {
            addCriterion("ROLEBASEMAXMOMENTUM <", value, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEBASEMAXMOMENTUM <=", value, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumIn(List<Integer> values) {
            addCriterion("ROLEBASEMAXMOMENTUM in", values, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumNotIn(List<Integer> values) {
            addCriterion("ROLEBASEMAXMOMENTUM not in", values, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumBetween(Integer value1, Integer value2) {
            addCriterion("ROLEBASEMAXMOMENTUM between", value1, value2, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebasemaxmomentumNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEBASEMAXMOMENTUM not between", value1, value2, "rolebasemaxmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumIsNull() {
            addCriterion("ROLEBASEMINMOMENTUM is null");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumIsNotNull() {
            addCriterion("ROLEBASEMINMOMENTUM is not null");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumEqualTo(Integer value) {
            addCriterion("ROLEBASEMINMOMENTUM =", value, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumNotEqualTo(Integer value) {
            addCriterion("ROLEBASEMINMOMENTUM <>", value, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumGreaterThan(Integer value) {
            addCriterion("ROLEBASEMINMOMENTUM >", value, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEBASEMINMOMENTUM >=", value, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumLessThan(Integer value) {
            addCriterion("ROLEBASEMINMOMENTUM <", value, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEBASEMINMOMENTUM <=", value, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumIn(List<Integer> values) {
            addCriterion("ROLEBASEMINMOMENTUM in", values, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumNotIn(List<Integer> values) {
            addCriterion("ROLEBASEMINMOMENTUM not in", values, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumBetween(Integer value1, Integer value2) {
            addCriterion("ROLEBASEMINMOMENTUM between", value1, value2, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolebaseminmomentumNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEBASEMINMOMENTUM not between", value1, value2, "rolebaseminmomentum");
            return (Criteria) this;
        }

        public Criteria andRolesualIsNull() {
            addCriterion("ROLESUAL is null");
            return (Criteria) this;
        }

        public Criteria andRolesualIsNotNull() {
            addCriterion("ROLESUAL is not null");
            return (Criteria) this;
        }

        public Criteria andRolesualEqualTo(Integer value) {
            addCriterion("ROLESUAL =", value, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualNotEqualTo(Integer value) {
            addCriterion("ROLESUAL <>", value, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualGreaterThan(Integer value) {
            addCriterion("ROLESUAL >", value, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLESUAL >=", value, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualLessThan(Integer value) {
            addCriterion("ROLESUAL <", value, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualLessThanOrEqualTo(Integer value) {
            addCriterion("ROLESUAL <=", value, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualIn(List<Integer> values) {
            addCriterion("ROLESUAL in", values, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualNotIn(List<Integer> values) {
            addCriterion("ROLESUAL not in", values, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualBetween(Integer value1, Integer value2) {
            addCriterion("ROLESUAL between", value1, value2, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolesualNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLESUAL not between", value1, value2, "rolesual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualIsNull() {
            addCriterion("ROLEMAXSUAL is null");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualIsNotNull() {
            addCriterion("ROLEMAXSUAL is not null");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualEqualTo(Integer value) {
            addCriterion("ROLEMAXSUAL =", value, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualNotEqualTo(Integer value) {
            addCriterion("ROLEMAXSUAL <>", value, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualGreaterThan(Integer value) {
            addCriterion("ROLEMAXSUAL >", value, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXSUAL >=", value, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualLessThan(Integer value) {
            addCriterion("ROLEMAXSUAL <", value, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXSUAL <=", value, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualIn(List<Integer> values) {
            addCriterion("ROLEMAXSUAL in", values, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualNotIn(List<Integer> values) {
            addCriterion("ROLEMAXSUAL not in", values, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXSUAL between", value1, value2, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolemaxsualNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXSUAL not between", value1, value2, "rolemaxsual");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryIsNull() {
            addCriterion("ROLESUALRECOVERY is null");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryIsNotNull() {
            addCriterion("ROLESUALRECOVERY is not null");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryEqualTo(Integer value) {
            addCriterion("ROLESUALRECOVERY =", value, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryNotEqualTo(Integer value) {
            addCriterion("ROLESUALRECOVERY <>", value, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryGreaterThan(Integer value) {
            addCriterion("ROLESUALRECOVERY >", value, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLESUALRECOVERY >=", value, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryLessThan(Integer value) {
            addCriterion("ROLESUALRECOVERY <", value, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryLessThanOrEqualTo(Integer value) {
            addCriterion("ROLESUALRECOVERY <=", value, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryIn(List<Integer> values) {
            addCriterion("ROLESUALRECOVERY in", values, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryNotIn(List<Integer> values) {
            addCriterion("ROLESUALRECOVERY not in", values, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryBetween(Integer value1, Integer value2) {
            addCriterion("ROLESUALRECOVERY between", value1, value2, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRolesualrecoveryNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLESUALRECOVERY not between", value1, value2, "rolesualrecovery");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesIsNull() {
            addCriterion("ROLEEXPERIENCES is null");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesIsNotNull() {
            addCriterion("ROLEEXPERIENCES is not null");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesEqualTo(Integer value) {
            addCriterion("ROLEEXPERIENCES =", value, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesNotEqualTo(Integer value) {
            addCriterion("ROLEEXPERIENCES <>", value, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesGreaterThan(Integer value) {
            addCriterion("ROLEEXPERIENCES >", value, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEEXPERIENCES >=", value, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesLessThan(Integer value) {
            addCriterion("ROLEEXPERIENCES <", value, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEEXPERIENCES <=", value, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesIn(List<Integer> values) {
            addCriterion("ROLEEXPERIENCES in", values, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesNotIn(List<Integer> values) {
            addCriterion("ROLEEXPERIENCES not in", values, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesBetween(Integer value1, Integer value2) {
            addCriterion("ROLEEXPERIENCES between", value1, value2, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRoleexperiencesNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEEXPERIENCES not between", value1, value2, "roleexperiences");
            return (Criteria) this;
        }

        public Criteria andRolelevelIsNull() {
            addCriterion("ROLELEVEL is null");
            return (Criteria) this;
        }

        public Criteria andRolelevelIsNotNull() {
            addCriterion("ROLELEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andRolelevelEqualTo(Integer value) {
            addCriterion("ROLELEVEL =", value, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelNotEqualTo(Integer value) {
            addCriterion("ROLELEVEL <>", value, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelGreaterThan(Integer value) {
            addCriterion("ROLELEVEL >", value, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLELEVEL >=", value, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelLessThan(Integer value) {
            addCriterion("ROLELEVEL <", value, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelLessThanOrEqualTo(Integer value) {
            addCriterion("ROLELEVEL <=", value, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelIn(List<Integer> values) {
            addCriterion("ROLELEVEL in", values, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelNotIn(List<Integer> values) {
            addCriterion("ROLELEVEL not in", values, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelBetween(Integer value1, Integer value2) {
            addCriterion("ROLELEVEL between", value1, value2, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolelevelNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLELEVEL not between", value1, value2, "rolelevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderIsNull() {
            addCriterion("ROLEMURDER is null");
            return (Criteria) this;
        }

        public Criteria andRolemurderIsNotNull() {
            addCriterion("ROLEMURDER is not null");
            return (Criteria) this;
        }

        public Criteria andRolemurderEqualTo(Integer value) {
            addCriterion("ROLEMURDER =", value, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderNotEqualTo(Integer value) {
            addCriterion("ROLEMURDER <>", value, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderGreaterThan(Integer value) {
            addCriterion("ROLEMURDER >", value, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEMURDER >=", value, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderLessThan(Integer value) {
            addCriterion("ROLEMURDER <", value, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEMURDER <=", value, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderIn(List<Integer> values) {
            addCriterion("ROLEMURDER in", values, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderNotIn(List<Integer> values) {
            addCriterion("ROLEMURDER not in", values, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMURDER between", value1, value2, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMURDER not between", value1, value2, "rolemurder");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelIsNull() {
            addCriterion("ROLEMURDERLEVEL is null");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelIsNotNull() {
            addCriterion("ROLEMURDERLEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelEqualTo(Integer value) {
            addCriterion("ROLEMURDERLEVEL =", value, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelNotEqualTo(Integer value) {
            addCriterion("ROLEMURDERLEVEL <>", value, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelGreaterThan(Integer value) {
            addCriterion("ROLEMURDERLEVEL >", value, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEMURDERLEVEL >=", value, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelLessThan(Integer value) {
            addCriterion("ROLEMURDERLEVEL <", value, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEMURDERLEVEL <=", value, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelIn(List<Integer> values) {
            addCriterion("ROLEMURDERLEVEL in", values, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelNotIn(List<Integer> values) {
            addCriterion("ROLEMURDERLEVEL not in", values, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMURDERLEVEL between", value1, value2, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andRolemurderlevelNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMURDERLEVEL not between", value1, value2, "rolemurderlevel");
            return (Criteria) this;
        }

        public Criteria andStateidIsNull() {
            addCriterion("STATEID is null");
            return (Criteria) this;
        }

        public Criteria andStateidIsNotNull() {
            addCriterion("STATEID is not null");
            return (Criteria) this;
        }

        public Criteria andStateidEqualTo(Integer value) {
            addCriterion("STATEID =", value, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidNotEqualTo(Integer value) {
            addCriterion("STATEID <>", value, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidGreaterThan(Integer value) {
            addCriterion("STATEID >", value, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATEID >=", value, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidLessThan(Integer value) {
            addCriterion("STATEID <", value, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidLessThanOrEqualTo(Integer value) {
            addCriterion("STATEID <=", value, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidIn(List<Integer> values) {
            addCriterion("STATEID in", values, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidNotIn(List<Integer> values) {
            addCriterion("STATEID not in", values, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidBetween(Integer value1, Integer value2) {
            addCriterion("STATEID between", value1, value2, "stateid");
            return (Criteria) this;
        }

        public Criteria andStateidNotBetween(Integer value1, Integer value2) {
            addCriterion("STATEID not between", value1, value2, "stateid");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateIsNull() {
            addCriterion("ROLESMALSTATE is null");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateIsNotNull() {
            addCriterion("ROLESMALSTATE is not null");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateEqualTo(Integer value) {
            addCriterion("ROLESMALSTATE =", value, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateNotEqualTo(Integer value) {
            addCriterion("ROLESMALSTATE <>", value, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateGreaterThan(Integer value) {
            addCriterion("ROLESMALSTATE >", value, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLESMALSTATE >=", value, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateLessThan(Integer value) {
            addCriterion("ROLESMALSTATE <", value, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateLessThanOrEqualTo(Integer value) {
            addCriterion("ROLESMALSTATE <=", value, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateIn(List<Integer> values) {
            addCriterion("ROLESMALSTATE in", values, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateNotIn(List<Integer> values) {
            addCriterion("ROLESMALSTATE not in", values, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateBetween(Integer value1, Integer value2) {
            addCriterion("ROLESMALSTATE between", value1, value2, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolesmalstateNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLESMALSTATE not between", value1, value2, "rolesmalstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateIsNull() {
            addCriterion("ROLEMAXSTATE is null");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateIsNotNull() {
            addCriterion("ROLEMAXSTATE is not null");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateEqualTo(Integer value) {
            addCriterion("ROLEMAXSTATE =", value, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateNotEqualTo(Integer value) {
            addCriterion("ROLEMAXSTATE <>", value, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateGreaterThan(Integer value) {
            addCriterion("ROLEMAXSTATE >", value, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXSTATE >=", value, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateLessThan(Integer value) {
            addCriterion("ROLEMAXSTATE <", value, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEMAXSTATE <=", value, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateIn(List<Integer> values) {
            addCriterion("ROLEMAXSTATE in", values, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateNotIn(List<Integer> values) {
            addCriterion("ROLEMAXSTATE not in", values, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXSTATE between", value1, value2, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolemaxstateNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEMAXSTATE not between", value1, value2, "rolemaxstate");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesIsNull() {
            addCriterion("ROLESTATEEXPERIES is null");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesIsNotNull() {
            addCriterion("ROLESTATEEXPERIES is not null");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesEqualTo(Integer value) {
            addCriterion("ROLESTATEEXPERIES =", value, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesNotEqualTo(Integer value) {
            addCriterion("ROLESTATEEXPERIES <>", value, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesGreaterThan(Integer value) {
            addCriterion("ROLESTATEEXPERIES >", value, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLESTATEEXPERIES >=", value, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesLessThan(Integer value) {
            addCriterion("ROLESTATEEXPERIES <", value, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesLessThanOrEqualTo(Integer value) {
            addCriterion("ROLESTATEEXPERIES <=", value, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesIn(List<Integer> values) {
            addCriterion("ROLESTATEEXPERIES in", values, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesNotIn(List<Integer> values) {
            addCriterion("ROLESTATEEXPERIES not in", values, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesBetween(Integer value1, Integer value2) {
            addCriterion("ROLESTATEEXPERIES between", value1, value2, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRolestateexperiesNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLESTATEEXPERIES not between", value1, value2, "rolestateexperies");
            return (Criteria) this;
        }

        public Criteria andRoleluckIsNull() {
            addCriterion("ROLELUCK is null");
            return (Criteria) this;
        }

        public Criteria andRoleluckIsNotNull() {
            addCriterion("ROLELUCK is not null");
            return (Criteria) this;
        }

        public Criteria andRoleluckEqualTo(Integer value) {
            addCriterion("ROLELUCK =", value, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckNotEqualTo(Integer value) {
            addCriterion("ROLELUCK <>", value, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckGreaterThan(Integer value) {
            addCriterion("ROLELUCK >", value, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLELUCK >=", value, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckLessThan(Integer value) {
            addCriterion("ROLELUCK <", value, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckLessThanOrEqualTo(Integer value) {
            addCriterion("ROLELUCK <=", value, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckIn(List<Integer> values) {
            addCriterion("ROLELUCK in", values, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckNotIn(List<Integer> values) {
            addCriterion("ROLELUCK not in", values, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckBetween(Integer value1, Integer value2) {
            addCriterion("ROLELUCK between", value1, value2, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRoleluckNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLELUCK not between", value1, value2, "roleluck");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumIsNull() {
            addCriterion("ROLELINGSHINUM is null");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumIsNotNull() {
            addCriterion("ROLELINGSHINUM is not null");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumEqualTo(Integer value) {
            addCriterion("ROLELINGSHINUM =", value, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumNotEqualTo(Integer value) {
            addCriterion("ROLELINGSHINUM <>", value, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumGreaterThan(Integer value) {
            addCriterion("ROLELINGSHINUM >", value, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLELINGSHINUM >=", value, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumLessThan(Integer value) {
            addCriterion("ROLELINGSHINUM <", value, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumLessThanOrEqualTo(Integer value) {
            addCriterion("ROLELINGSHINUM <=", value, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumIn(List<Integer> values) {
            addCriterion("ROLELINGSHINUM in", values, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumNotIn(List<Integer> values) {
            addCriterion("ROLELINGSHINUM not in", values, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumBetween(Integer value1, Integer value2) {
            addCriterion("ROLELINGSHINUM between", value1, value2, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolelingshinumNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLELINGSHINUM not between", value1, value2, "rolelingshinum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumIsNull() {
            addCriterion("ROLEXIANYUNUM is null");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumIsNotNull() {
            addCriterion("ROLEXIANYUNUM is not null");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumEqualTo(Integer value) {
            addCriterion("ROLEXIANYUNUM =", value, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumNotEqualTo(Integer value) {
            addCriterion("ROLEXIANYUNUM <>", value, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumGreaterThan(Integer value) {
            addCriterion("ROLEXIANYUNUM >", value, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumGreaterThanOrEqualTo(Integer value) {
            addCriterion("ROLEXIANYUNUM >=", value, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumLessThan(Integer value) {
            addCriterion("ROLEXIANYUNUM <", value, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumLessThanOrEqualTo(Integer value) {
            addCriterion("ROLEXIANYUNUM <=", value, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumIn(List<Integer> values) {
            addCriterion("ROLEXIANYUNUM in", values, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumNotIn(List<Integer> values) {
            addCriterion("ROLEXIANYUNUM not in", values, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumBetween(Integer value1, Integer value2) {
            addCriterion("ROLEXIANYUNUM between", value1, value2, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolexianyunumNotBetween(Integer value1, Integer value2) {
            addCriterion("ROLEXIANYUNUM not between", value1, value2, "rolexianyunum");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeIsNull() {
            addCriterion("ROLECREATTIME is null");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeIsNotNull() {
            addCriterion("ROLECREATTIME is not null");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeEqualTo(Date value) {
            addCriterion("ROLECREATTIME =", value, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeNotEqualTo(Date value) {
            addCriterion("ROLECREATTIME <>", value, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeGreaterThan(Date value) {
            addCriterion("ROLECREATTIME >", value, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ROLECREATTIME >=", value, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeLessThan(Date value) {
            addCriterion("ROLECREATTIME <", value, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeLessThanOrEqualTo(Date value) {
            addCriterion("ROLECREATTIME <=", value, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeIn(List<Date> values) {
            addCriterion("ROLECREATTIME in", values, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeNotIn(List<Date> values) {
            addCriterion("ROLECREATTIME not in", values, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeBetween(Date value1, Date value2) {
            addCriterion("ROLECREATTIME between", value1, value2, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andRolecreattimeNotBetween(Date value1, Date value2) {
            addCriterion("ROLECREATTIME not between", value1, value2, "rolecreattime");
            return (Criteria) this;
        }

        public Criteria andSoultimeIsNull() {
            addCriterion("SOULTIME is null");
            return (Criteria) this;
        }

        public Criteria andSoultimeIsNotNull() {
            addCriterion("SOULTIME is not null");
            return (Criteria) this;
        }

        public Criteria andSoultimeEqualTo(Long value) {
            addCriterion("SOULTIME =", value, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeNotEqualTo(Long value) {
            addCriterion("SOULTIME <>", value, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeGreaterThan(Long value) {
            addCriterion("SOULTIME >", value, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeGreaterThanOrEqualTo(Long value) {
            addCriterion("SOULTIME >=", value, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeLessThan(Long value) {
            addCriterion("SOULTIME <", value, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeLessThanOrEqualTo(Long value) {
            addCriterion("SOULTIME <=", value, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeIn(List<Long> values) {
            addCriterion("SOULTIME in", values, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeNotIn(List<Long> values) {
            addCriterion("SOULTIME not in", values, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeBetween(Long value1, Long value2) {
            addCriterion("SOULTIME between", value1, value2, "soultime");
            return (Criteria) this;
        }

        public Criteria andSoultimeNotBetween(Long value1, Long value2) {
            addCriterion("SOULTIME not between", value1, value2, "soultime");
            return (Criteria) this;
        }

        public Criteria andStorelingqiIsNull() {
            addCriterion("STORELINGQI is null");
            return (Criteria) this;
        }

        public Criteria andStorelingqiIsNotNull() {
            addCriterion("STORELINGQI is not null");
            return (Criteria) this;
        }

        public Criteria andStorelingqiEqualTo(Integer value) {
            addCriterion("STORELINGQI =", value, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiNotEqualTo(Integer value) {
            addCriterion("STORELINGQI <>", value, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiGreaterThan(Integer value) {
            addCriterion("STORELINGQI >", value, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiGreaterThanOrEqualTo(Integer value) {
            addCriterion("STORELINGQI >=", value, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiLessThan(Integer value) {
            addCriterion("STORELINGQI <", value, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiLessThanOrEqualTo(Integer value) {
            addCriterion("STORELINGQI <=", value, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiIn(List<Integer> values) {
            addCriterion("STORELINGQI in", values, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiNotIn(List<Integer> values) {
            addCriterion("STORELINGQI not in", values, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiBetween(Integer value1, Integer value2) {
            addCriterion("STORELINGQI between", value1, value2, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqiNotBetween(Integer value1, Integer value2) {
            addCriterion("STORELINGQI not between", value1, value2, "storelingqi");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitIsNull() {
            addCriterion("STORELINGQILIMIT is null");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitIsNotNull() {
            addCriterion("STORELINGQILIMIT is not null");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitEqualTo(Integer value) {
            addCriterion("STORELINGQILIMIT =", value, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitNotEqualTo(Integer value) {
            addCriterion("STORELINGQILIMIT <>", value, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitGreaterThan(Integer value) {
            addCriterion("STORELINGQILIMIT >", value, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitGreaterThanOrEqualTo(Integer value) {
            addCriterion("STORELINGQILIMIT >=", value, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitLessThan(Integer value) {
            addCriterion("STORELINGQILIMIT <", value, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitLessThanOrEqualTo(Integer value) {
            addCriterion("STORELINGQILIMIT <=", value, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitIn(List<Integer> values) {
            addCriterion("STORELINGQILIMIT in", values, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitNotIn(List<Integer> values) {
            addCriterion("STORELINGQILIMIT not in", values, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitBetween(Integer value1, Integer value2) {
            addCriterion("STORELINGQILIMIT between", value1, value2, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andStorelingqilimitNotBetween(Integer value1, Integer value2) {
            addCriterion("STORELINGQILIMIT not between", value1, value2, "storelingqilimit");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationIsNull() {
            addCriterion("LINGQUANLOCATION is null");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationIsNotNull() {
            addCriterion("LINGQUANLOCATION is not null");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationEqualTo(Byte value) {
            addCriterion("LINGQUANLOCATION =", value, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationNotEqualTo(Byte value) {
            addCriterion("LINGQUANLOCATION <>", value, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationGreaterThan(Byte value) {
            addCriterion("LINGQUANLOCATION >", value, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationGreaterThanOrEqualTo(Byte value) {
            addCriterion("LINGQUANLOCATION >=", value, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationLessThan(Byte value) {
            addCriterion("LINGQUANLOCATION <", value, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationLessThanOrEqualTo(Byte value) {
            addCriterion("LINGQUANLOCATION <=", value, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationIn(List<Byte> values) {
            addCriterion("LINGQUANLOCATION in", values, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationNotIn(List<Byte> values) {
            addCriterion("LINGQUANLOCATION not in", values, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationBetween(Byte value1, Byte value2) {
            addCriterion("LINGQUANLOCATION between", value1, value2, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andLingquanlocationNotBetween(Byte value1, Byte value2) {
            addCriterion("LINGQUANLOCATION not between", value1, value2, "lingquanlocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationIsNull() {
            addCriterion("GONGLOCATION is null");
            return (Criteria) this;
        }

        public Criteria andGonglocationIsNotNull() {
            addCriterion("GONGLOCATION is not null");
            return (Criteria) this;
        }

        public Criteria andGonglocationEqualTo(Byte value) {
            addCriterion("GONGLOCATION =", value, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationNotEqualTo(Byte value) {
            addCriterion("GONGLOCATION <>", value, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationGreaterThan(Byte value) {
            addCriterion("GONGLOCATION >", value, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationGreaterThanOrEqualTo(Byte value) {
            addCriterion("GONGLOCATION >=", value, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationLessThan(Byte value) {
            addCriterion("GONGLOCATION <", value, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationLessThanOrEqualTo(Byte value) {
            addCriterion("GONGLOCATION <=", value, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationIn(List<Byte> values) {
            addCriterion("GONGLOCATION in", values, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationNotIn(List<Byte> values) {
            addCriterion("GONGLOCATION not in", values, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationBetween(Byte value1, Byte value2) {
            addCriterion("GONGLOCATION between", value1, value2, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andGonglocationNotBetween(Byte value1, Byte value2) {
            addCriterion("GONGLOCATION not between", value1, value2, "gonglocation");
            return (Criteria) this;
        }

        public Criteria andLiqitimeIsNull() {
            addCriterion("LIQITIME is null");
            return (Criteria) this;
        }

        public Criteria andLiqitimeIsNotNull() {
            addCriterion("LIQITIME is not null");
            return (Criteria) this;
        }

        public Criteria andLiqitimeEqualTo(Long value) {
            addCriterion("LIQITIME =", value, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeNotEqualTo(Long value) {
            addCriterion("LIQITIME <>", value, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeGreaterThan(Long value) {
            addCriterion("LIQITIME >", value, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeGreaterThanOrEqualTo(Long value) {
            addCriterion("LIQITIME >=", value, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeLessThan(Long value) {
            addCriterion("LIQITIME <", value, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeLessThanOrEqualTo(Long value) {
            addCriterion("LIQITIME <=", value, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeIn(List<Long> values) {
            addCriterion("LIQITIME in", values, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeNotIn(List<Long> values) {
            addCriterion("LIQITIME not in", values, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeBetween(Long value1, Long value2) {
            addCriterion("LIQITIME between", value1, value2, "liqitime");
            return (Criteria) this;
        }

        public Criteria andLiqitimeNotBetween(Long value1, Long value2) {
            addCriterion("LIQITIME not between", value1, value2, "liqitime");
            return (Criteria) this;
        }

        public Criteria andRolenameLikeInsensitive(String value) {
            addCriterion("upper(ROLENAME) like", value.toUpperCase(), "rolename");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}